---
id: jan_2020_2_1_0
title: January 2020 (version 2.1.0)
sidebar_label: January 2020 (2.1.0)
---

Welcome to the first release of Querybook this year 🎉.

Following are the top new features we have added during these past two months:

-   **Advanced Querybook Charting**: Transform data and create charts right from the query results! Added new chart types and customizations.
-   **Collections**: Marie Kondo your workspace by grouping your DataDocs and favorite tables into lists!
-   **Improved Ad Hoc Querying**: Convert a past run into an ad hoc execution with one click! Also draft ad hoc queries are now persistent as you navigate.
-   **Viewer Badge**: Know your consumers! Each doc & table now has a badge to show the total number of views. Clicking it shows its top visitors and trends over time.
-   **Quick Table Reference**: Double click bliss! You can now double click on a table to open it in a new persistent left sidebar when viewing a DataDoc.

## Charting

#### New Charting Features

-   Additional Data Source Types
    -   Pick from any execution or let the chart update every time the query runs
-   Transform Data
    -   Aggregate data - averages, counts, sums, min/max/median
    -   Switch rows and columns
-   More Chart Types!
    -   Stacked Area
    -   Bar (+stacked)
    -   Horizontal Bar (+stacked)
    -   Pie
    -   Doughnut
    -   Scatter
    -   Table
-   Detailed Display Options!
    -   Pick any column as x-axis
    -   Customize which series to display
    -   Titles, labels, legend positions, and more!

#### Chart Source/Type Example

![](/changelog/20200121/graph1.gif)

#### Data Aggregation Example

![](/changelog/20200121/graph2.gif)

## Lists

List introduces a new way to organize any relevant and accessible data docs and tables together.

![](/changelog/20200121/board4.gif)

#### Creating a list

Create a list by going to the list tab and clicking on the “+” button. List's name is the only required field and does not need to be unique.
![](/changelog/20200121/board1.gif)

Once a list is created, you can add any data docs and tables. Clicking an already added doc/table will remove it from the list.
![](/changelog/20200121/board2.gif)
![](/changelog/20200121/board3.gif)

Querybook Team<br/>
Charlie, Gu, Lena Ryoo<br/>
Pinterest<br/>
🚀
